The following is a guide on the minimum recommended setup needed to run Pyramid when installed 'natively'. This does not mean it is the recommended setup.
- These recommendations are different for Kubernetes deployments.
Native Installations
|
Item |
Setting |
Comment |
|---|---|---|
Server OS |
|
|
|
Host Operating System |
Windows:
|
|
|
Linux:
|
|
|
Server Hardware |
||
|
Host CPUs
|
|
Production environments should provide ample CPUs to process queries. See suggestions below.
|
|
||
|
||
|
Host Memory
|
|
Production environments should provide ample memory to host the application, in-memory databases, as well as the needs of the operating system itself. See suggestions below. |
|
||
|
||
|
Host Disk |
|
Use of very fast disks, such as SSDs, is highly recommended. |
Client |
|
|
|
Client Browser |
|
Chrome, Edge, Opera, FireFox, Safari etc.The client browser can operate on any operating system, as long as it can connect to the web application hosted on the relevant server. |
|
Client Screen Resolution |
|
The desktop client must support the minimum screen size to operate effectively. |
Database Repository |
||
|
Repository Type |
|
See details below on deprecated databases. For more information about supported SQL versions, see Microsoft SQL Server Lifecycle. |
|
See details below on deprecated databases. |
|
|
See details below on deprecated databases. |
|
|
Database sizing |
|
If the repository is not hosted on the cloud, then very fast disks, such as SSDs, are required. |
|
Host Disk |
|
Ensure there is sufficient space to handle a growing repo database. |
Deprecations
Pyramid 2023
Main Release
Internet Explorer 11 is no longer supported from Pyramid 2023.00 onwards.
2023.12
- Pyramid 2023.12 is the last version that will support Windows Server 2012. Customers must move off this OS.
- Ubuntu 16 and 18, CentOS 7, and RedHat 7 are all coming to end of life soon. Customers should start planning to move off these OS's
- Pyramid 2023.12 is the last version to support PostgreSQL 11, MS SQL 2012, and Oracle 10c. Customers must move off these database versions. Note that they can still be used as analytical data sources.
2023.13
Pyramid 2023.13 is the last version that will support Debian 10, Ubuntu 16 and 18, CentOS 7, Oracle Linux 7 and RedHat 7. Customers must move off these operating systems for continued, supported operations with all releases are 2023.13.
2023.15
Pyramid 2023.15 onwards has changed the MS SQL Server driver that does not officially support MS SQL Server 2012 or earlier. This impacts both repositories and analytical databases.
Hardware and Environment
The right setup is heavily affected by the specifics of each deployment. There are countless variables that need to be quantified and considered. The guide to scaling Pyramid provides an in-depth review of these items. Briefly, some of these considerations include:
- Number of concurrent users : This variable will heavily influence the number of CPU's needed to keep performance optimal.
- Query styles and consumption: If your users typically run very large queries (5,000+ rows) and do this consistently, the underlying hardware should provide enough CPU cores to not only process such large responses, but also provide enough bandwidth for other users while such queries are being processed. Networking speed will also have an impact as more data is streamed to the end users.
- Size of the databases and the types of technologies they operate in: In-memory databases will require lots of memory to host the relevant databases. On-disk technologies are less sensitive to memory, but will require VERY fast disk access. OLAP usually needs both, but does not require the same memory footprint or amount of disk space. Generally, In-memory and memory based OLAP engines require strong CPU's.
- Up time and back-ups: Multi-Server deployments are best suited to ensuring the highest up-time, which in means that both the hardware strategy for the application as well as the location and performance of the server hosting the database repository is important (which remains central).